* DHS Calendar Tutorial - Example 9. * Calculating discontinuation rates using event files. * note that the denominator in this table is all women, and includes sterilized women * and also includes missing methods to match the final reports. * change to a working directory where the data are stored * or add the full path to the 'use' command below. cd "C:\Users\21180\OneDrive - ICF\Data\DHS_model". * open the event file dataset created by the 'create events file.sps'. get file="eventsfile.sav". * name the dataset. dataset name eventsfile. * Step 1. * calculate exposure, late entries and censoring for the period 3-62 months prior to the interview. * weight variable. compute wt=v005/1000000. * weight will be applied later when we need it in step 3. * drop events that were ongoing when calendar began, * keeping those that started after the start of the calendar. select if (ev900 > v017). * drop births, terminations, pregnancies, and episodes of non-use * keep missing methods. to exclude, drop "| ev902 = 99". select if (ev902 <> 0 & (ev902 < 80 | ev902 = 99)). * time from beginning of event to interview. compute tbeg_int = v008 - ev900. variable labels tbeg_int "time from beginning of event to interview". * time from end of event to interview. compute tend_int = v008 - ev901. variable labels tend_int "time from end of event to interview". formats tbeg_int tend_int (f2.0). * discontinuation variable. compute discont = 0. if (ev903 <> 0) discont = 1. * censoring those who discontinue in last three months. if (tend_int < 3) discont = 0. variable labels discont "Discontinuation indicator". value labels discont 0 "No discontinuation" 1 "Discontinuation". formats discont (f1.0). frequencies variables=discont. Frequencies Notes |-----------------------------------------------------|-----------------------------------------------------------| |Output Created |15-SEP-2018 16:20:27 | |-----------------------------------------------------|-----------------------------------------------------------| |Comments | | |----------------------|------------------------------|-----------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav| | |------------------------------|-----------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-----------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-----------------------------------------------------------| | |Filter | | | |------------------------------|-----------------------------------------------------------| | |Weight | | | |------------------------------|-----------------------------------------------------------| | |Split File | | | |------------------------------|-----------------------------------------------------------| | |N of Rows in Working Data File|2563 | |----------------------|------------------------------|-----------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-----------------------------------------------------------| | |Cases Used |Statistics are based on all cases with valid data. | |-----------------------------------------------------|-----------------------------------------------------------| |Syntax |frequencies variables=discont. | |----------------------|------------------------------|-----------------------------------------------------------| |Resources |Processor Time |00:00:00.06 | | |------------------------------|-----------------------------------------------------------| | |Elapsed Time |00:00:00.05 | |-----------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Statistics Discontinuation indicator |-|-------|----| |N|Valid |2563| | |-------|----| | |Missing|0 | |--------------| Discontinuation indicator |------------------------|---------|-------|-------------|------------------| | |Frequency|Percent|Valid Percent|Cumulative Percent| |-----|------------------|---------|-------|-------------|------------------| |Valid|No discontinuation|1822 |71.1 |71.1 |71.1 | | |------------------|---------|-------|-------------|------------------| | |Discontinuation |741 |28.9 |28.9 |100.0 | | |------------------|---------|-------|-------------|------------------| | |Total |2563 |100.0 |100.0 | | |---------------------------------------------------------------------------| crosstabs tables=ev903 by discont /cells=count column /count=asis. Crosstabs Notes |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Output Created |15-SEP-2018 16:20:27 | |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Comments | | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Filter | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Weight | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Split File | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |N of Rows in Working Data File|2563 | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cases Used |Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.| |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Syntax |crosstabs tables=ev903 by discont /cells=count column /count=asis. | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Resources |Processor Time |00:00:00.03 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Elapsed Time |00:00:00.04 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Dimensions Requested |2 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cells Available |131029 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Case Processing Summary |------------------------------------------------|-------------------------------------------| | |Cases | | |-------------|---------------|-------------| | |Valid |Missing |Total | | |-----|-------|-------|-------|-----|-------| | |N |Percent|N |Percent|N |Percent| |------------------------------------------------|-----|-------|-------|-------|-----|-------| |Discontinuation code * Discontinuation indicator|784 |30.6% |1779 |69.4% |2563 |100.0% | |--------------------------------------------------------------------------------------------| Discontinuation code * Discontinuation indicator Crosstabulation |-------------------------------------------------------------------------------------------|-----------------------------------------|------| | |Discontinuation indicator |Total | | |-------------------------|---------------| | | |No discontinuation |Discontinuation| | |--------------------|-----------------------------------|----------------------------------|-------------------------|---------------|------| |Discontinuation code|Became pregnant while using |Count |1 |50 |51 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|2.3% |6.7% |6.5% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Wanted to become pregnant |Count |9 |203 |212 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|20.9% |27.4% |27.0% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Husband disapproved |Count |1 |35 |36 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|2.3% |4.7% |4.6% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Side effects |Count |17 |274 |291 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|39.5% |37.0% |37.1% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Access/availability |Count |1 |14 |15 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|2.3% |1.9% |1.9% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Wanted more effective method |Count |5 |57 |62 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|11.6% |7.7% |7.9% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Inconvenient to use |Count |3 |29 |32 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|7.0% |3.9% |4.1% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Infrequent sex/husband away |Count |2 |18 |20 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|4.7% |2.4% |2.6% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Cost |Count |2 |7 |9 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|4.7% |0.9% |1.1% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Fatalistic |Count |0 |17 |17 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|0.0% |2.3% |2.2% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Difficult to get pregnant/menopause|Count |0 |2 |2 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|0.0% |0.3% |0.3% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Other |Count |0 |7 |7 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|0.0% |0.9% |0.9% | | |-----------------------------------|----------------------------------|-------------------------|---------------|------| | |Missing |Count |2 |28 |30 | | | |----------------------------------|-------------------------|---------------|------| | | |% within Discontinuation indicator|4.7% |3.8% |3.8% | |--------------------------------------------------------|----------------------------------|-------------------------|---------------|------| |Total |Count |43 |741 |784 | | |----------------------------------|-------------------------|---------------|------| | |% within Discontinuation indicator|100.0% |100.0% |100.0%| |--------------------------------------------------------------------------------------------------------------------------------------------| * generate late entry variable. compute entry = 0. if (tbeg_int >= 63) entry = tbeg_int - 62. variable labels entry "Late entry months". formats entry (f1.0). crosstabs tables=tbeg_int by entry /count=asis. Crosstabs Notes |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Output Created |15-SEP-2018 16:20:27 | |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Comments | | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Filter | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Weight | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Split File | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |N of Rows in Working Data File|2563 | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cases Used |Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.| |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Syntax |crosstabs tables=tbeg_int by entry /count=asis. | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Resources |Processor Time |00:00:00.05 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Elapsed Time |00:00:00.05 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Dimensions Requested |2 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cells Available |131029 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Case Processing Summary |-------------------------------------------------------------|-------------------------------------------| | |Cases | | |-------------|---------------|-------------| | |Valid |Missing |Total | | |-----|-------|-------|-------|-----|-------| | |N |Percent|N |Percent|N |Percent| |-------------------------------------------------------------|-----|-------|-------|-------|-----|-------| |time from beginning of event to interview * Late entry months|2563 |100.0% |0 |0.0% |2563 |100.0% | |---------------------------------------------------------------------------------------------------------| time from beginning of event to interview * Late entry months Crosstabulation Count |--------------------------------------------|------------------------------|-----| | |Late entry months |Total| | |-----------------|--|--|--|-|-| | | |0 |1 |2 |3 |4|5| | |-----------------------------------------|--|-----------------|--|--|--|-|-|-----| |time from beginning of event to interview|0 |40 |0 |0 |0 |0|0|40 | | |--|-----------------|--|--|--|-|-|-----| | |1 |97 |0 |0 |0 |0|0|97 | | |--|-----------------|--|--|--|-|-|-----| | |2 |70 |0 |0 |0 |0|0|70 | | |--|-----------------|--|--|--|-|-|-----| | |3 |64 |0 |0 |0 |0|0|64 | | |--|-----------------|--|--|--|-|-|-----| | |4 |55 |0 |0 |0 |0|0|55 | | |--|-----------------|--|--|--|-|-|-----| | |5 |83 |0 |0 |0 |0|0|83 | | |--|-----------------|--|--|--|-|-|-----| | |6 |95 |0 |0 |0 |0|0|95 | | |--|-----------------|--|--|--|-|-|-----| | |7 |80 |0 |0 |0 |0|0|80 | | |--|-----------------|--|--|--|-|-|-----| | |8 |68 |0 |0 |0 |0|0|68 | | |--|-----------------|--|--|--|-|-|-----| | |9 |48 |0 |0 |0 |0|0|48 | | |--|-----------------|--|--|--|-|-|-----| | |10|49 |0 |0 |0 |0|0|49 | | |--|-----------------|--|--|--|-|-|-----| | |11|53 |0 |0 |0 |0|0|53 | | |--|-----------------|--|--|--|-|-|-----| | |12|76 |0 |0 |0 |0|0|76 | | |--|-----------------|--|--|--|-|-|-----| | |13|56 |0 |0 |0 |0|0|56 | | |--|-----------------|--|--|--|-|-|-----| | |14|45 |0 |0 |0 |0|0|45 | | |--|-----------------|--|--|--|-|-|-----| | |15|54 |0 |0 |0 |0|0|54 | | |--|-----------------|--|--|--|-|-|-----| | |16|60 |0 |0 |0 |0|0|60 | | |--|-----------------|--|--|--|-|-|-----| | |17|72 |0 |0 |0 |0|0|72 | | |--|-----------------|--|--|--|-|-|-----| | |18|74 |0 |0 |0 |0|0|74 | | |--|-----------------|--|--|--|-|-|-----| | |19|57 |0 |0 |0 |0|0|57 | | |--|-----------------|--|--|--|-|-|-----| | |20|59 |0 |0 |0 |0|0|59 | | |--|-----------------|--|--|--|-|-|-----| | |21|30 |0 |0 |0 |0|0|30 | | |--|-----------------|--|--|--|-|-|-----| | |22|21 |0 |0 |0 |0|0|21 | | |--|-----------------|--|--|--|-|-|-----| | |23|39 |0 |0 |0 |0|0|39 | | |--|-----------------|--|--|--|-|-|-----| | |24|40 |0 |0 |0 |0|0|40 | | |--|-----------------|--|--|--|-|-|-----| | |25|37 |0 |0 |0 |0|0|37 | | |--|-----------------|--|--|--|-|-|-----| | |26|38 |0 |0 |0 |0|0|38 | | |--|-----------------|--|--|--|-|-|-----| | |27|45 |0 |0 |0 |0|0|45 | | |--|-----------------|--|--|--|-|-|-----| | |28|46 |0 |0 |0 |0|0|46 | | |--|-----------------|--|--|--|-|-|-----| | |29|34 |0 |0 |0 |0|0|34 | | |--|-----------------|--|--|--|-|-|-----| | |30|50 |0 |0 |0 |0|0|50 | | |--|-----------------|--|--|--|-|-|-----| | |31|37 |0 |0 |0 |0|0|37 | | |--|-----------------|--|--|--|-|-|-----| | |32|33 |0 |0 |0 |0|0|33 | | |--|-----------------|--|--|--|-|-|-----| | |33|28 |0 |0 |0 |0|0|28 | | |--|-----------------|--|--|--|-|-|-----| | |34|24 |0 |0 |0 |0|0|24 | | |--|-----------------|--|--|--|-|-|-----| | |35|26 |0 |0 |0 |0|0|26 | | |--|-----------------|--|--|--|-|-|-----| | |36|43 |0 |0 |0 |0|0|43 | | |--|-----------------|--|--|--|-|-|-----| | |37|38 |0 |0 |0 |0|0|38 | | |--|-----------------|--|--|--|-|-|-----| | |38|36 |0 |0 |0 |0|0|36 | | |--|-----------------|--|--|--|-|-|-----| | |39|34 |0 |0 |0 |0|0|34 | | |--|-----------------|--|--|--|-|-|-----| | |40|39 |0 |0 |0 |0|0|39 | | |--|-----------------|--|--|--|-|-|-----| | |41|27 |0 |0 |0 |0|0|27 | | |--|-----------------|--|--|--|-|-|-----| | |42|27 |0 |0 |0 |0|0|27 | | |--|-----------------|--|--|--|-|-|-----| | |43|24 |0 |0 |0 |0|0|24 | | |--|-----------------|--|--|--|-|-|-----| | |44|27 |0 |0 |0 |0|0|27 | | |--|-----------------|--|--|--|-|-|-----| | |45|24 |0 |0 |0 |0|0|24 | | |--|-----------------|--|--|--|-|-|-----| | |46|13 |0 |0 |0 |0|0|13 | | |--|-----------------|--|--|--|-|-|-----| | |47|28 |0 |0 |0 |0|0|28 | | |--|-----------------|--|--|--|-|-|-----| | |48|27 |0 |0 |0 |0|0|27 | | |--|-----------------|--|--|--|-|-|-----| | |49|28 |0 |0 |0 |0|0|28 | | |--|-----------------|--|--|--|-|-|-----| | |50|18 |0 |0 |0 |0|0|18 | | |--|-----------------|--|--|--|-|-|-----| | |51|17 |0 |0 |0 |0|0|17 | | |--|-----------------|--|--|--|-|-|-----| | |52|22 |0 |0 |0 |0|0|22 | | |--|-----------------|--|--|--|-|-|-----| | |53|19 |0 |0 |0 |0|0|19 | | |--|-----------------|--|--|--|-|-|-----| | |54|26 |0 |0 |0 |0|0|26 | | |--|-----------------|--|--|--|-|-|-----| | |55|19 |0 |0 |0 |0|0|19 | | |--|-----------------|--|--|--|-|-|-----| | |56|21 |0 |0 |0 |0|0|21 | | |--|-----------------|--|--|--|-|-|-----| | |57|14 |0 |0 |0 |0|0|14 | | |--|-----------------|--|--|--|-|-|-----| | |58|11 |0 |0 |0 |0|0|11 | | |--|-----------------|--|--|--|-|-|-----| | |59|7 |0 |0 |0 |0|0|7 | | |--|-----------------|--|--|--|-|-|-----| | |60|13 |0 |0 |0 |0|0|13 | | |--|-----------------|--|--|--|-|-|-----| | |61|20 |0 |0 |0 |0|0|20 | | |--|-----------------|--|--|--|-|-|-----| | |62|10 |0 |0 |0 |0|0|10 | | |--|-----------------|--|--|--|-|-|-----| | |63|0 |16|0 |0 |0|0|16 | | |--|-----------------|--|--|--|-|-|-----| | |64|0 |0 |18|0 |0|0|18 | | |--|-----------------|--|--|--|-|-|-----| | |65|0 |0 |0 |10|0|0|10 | | |--|-----------------|--|--|--|-|-|-----| | |66|0 |0 |0 |0 |2|0|2 | | |--|-----------------|--|--|--|-|-|-----| | |67|0 |0 |0 |0 |0|2|2 | |--------------------------------------------|-----------------|--|--|--|-|-|-----| |Total |2515 |16|18|10|2|2|2563 | |---------------------------------------------------------------------------------| * taking away exposure time outside of the 3 to 62 month window. compute exposure = ev901a. if (tend_int < 3) exposure = ev901a - (3 - tend_int). recode exposure (-3 thru 0=0). variable labels exposure "Exposure". formats exposure (f2.0). * drop those events that started in the month of the interview and two months prior. select if (tbeg_int >= 3). * drop events that started and ended before 62 months prior to survey. select if (tbeg_int <= 62 | tend_int <= 62). * to remove episodes from sterilized women from denominator use the command below - not for DHS standard. /* if (ev902 = 6) exposure=$sysmis. */ * censor any discontinuations that are associated with use > 59 months. * not censored in this example. /* if ((exposure - entry) > 59) discont = 0. */ * Step 2. * Recode methods, reasons for discontinuations, and create switching variable. * recode contraceptive method. * IUD, Periodic Abstinence, and Withdrawal skipped and grouped with other due to small numbers of cases. recode ev902 (sysmis = sysmis) (1 = 1) /*(2 = 2)*/ (3 = 3) (11 = 4) (5 = 5) /*(8 = 6)*/ /*(9 = 7)*/ (13 18 = 8) (else = 9) into method. variable labels method "Contraceptive method". value labels method 1 "Pill" 2 "IUD" 3 "Injectables" 4 "Implant" 5 "Male condom" 6 "Periodic abstinence" 7 "Withdrawal" 8 "LAM/EC" 9 "Other [6]" 99 "All methods". /* used later */ * LAM and Emergency contraception are grouped here. * Other category is Female Sterilization, Male sterilization, Other Traditional, * Female Condom, Other Modern, Standard Days Method. * plus IUD, Periodic Abstinence, Withdrawal. formats method (f1.0). crosstabs tables=ev902 by method /count=asis. Crosstabs Notes |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Output Created |15-SEP-2018 16:20:28 | |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Comments | | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Filter | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Weight | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Split File | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |N of Rows in Working Data File|2356 | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cases Used |Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.| |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Syntax |crosstabs tables=ev902 by method /count=asis. | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Resources |Processor Time |00:00:00.06 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Elapsed Time |00:00:00.05 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Dimensions Requested |2 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cells Available |131029 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Case Processing Summary |---------------------------------|-------------------------------------------| | |Cases | | |-------------|---------------|-------------| | |Valid |Missing |Total | | |-----|-------|-------|-------|-----|-------| | |N |Percent|N |Percent|N |Percent| |---------------------------------|-----|-------|-------|-------|-----|-------| |Event code * Contraceptive method|2356 |100.0% |0 |0.0% |2356 |100.0% | |-----------------------------------------------------------------------------| Event code * Contraceptive method Crosstabulation Count |----------------------------------------|---------------------------------------------------------------------|-----| | |Contraceptive method |Total| | |--------------------|-----------|-------|-----------|------|---------| | | |Pill |Injectables|Implant|Male condom|LAM/EC|Other [6]| | |----------|-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| |Event code|Pill |587 |0 |0 |0 |0 |0 |587 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |IUD |0 |0 |0 |0 |0 |36 |36 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Injectable |0 |1029 |0 |0 |0 |0 |1029 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Condom |0 |0 |0 |80 |0 |0 |80 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Female sterilization |0 |0 |0 |0 |0 |18 |18 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Male sterilization |0 |0 |0 |0 |0 |1 |1 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Periodic abstinence/Rhythm |0 |0 |0 |0 |0 |12 |12 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Withdrawal |0 |0 |0 |0 |0 |14 |14 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Other traditional methods |0 |0 |0 |0 |0 |73 |73 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Norplant |0 |0 |374 |0 |0 |0 |374 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Lactational amenorrhea method|0 |0 |0 |0 |114 |0 |114 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Female condom |0 |0 |0 |0 |0 |1 |1 | | |-----------------------------|--------------------|-----------|-------|-----------|------|---------|-----| | |Other modern method |0 |0 |0 |0 |0 |17 |17 | |----------------------------------------|--------------------|-----------|-------|-----------|------|---------|-----| |Total |587 |1029 |374 |80 |114 |172 |2356 | |--------------------------------------------------------------------------------------------------------------------| * filter for discontinuations only. compute filter$ = (discont = 1). filter by filter$. * recode reasons for discontinuation - ignoring switching. recode ev903 (0 sysmis = sysmis) (1 = 1 /* Method failure */) (2 = 2 /* Desire to become pregnant */) (9 12 13 = 3 /* Other fertility related reasons */) (4 5 = 4 /* Side effects/health concerns */) (7 = 5 /* Wanted more effective method */) (6 8 10 = 6 /* Other method related */) (else = 7 /* Other/DK */) into reason. variable labels reason "Reason for discontinuation". value labels reason 1 "Method failure" 2 "Desire to become pregnant" 3 "Other fertility related reasons" 4 "Side effects/health concerns" 5 "Wanted more effective method" 6 "Other method related" 7 "Other/DK". formats reason (f1.0). if (discont <> 1) reason = $sysmis. frequencies variables=reason. Frequencies Notes |-----------------------------------------------------|-----------------------------------------------------------| |Output Created |15-SEP-2018 16:20:28 | |-----------------------------------------------------|-----------------------------------------------------------| |Comments | | |----------------------|------------------------------|-----------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav| | |------------------------------|-----------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-----------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-----------------------------------------------------------| | |Filter |filter$ | | |------------------------------|-----------------------------------------------------------| | |Weight | | | |------------------------------|-----------------------------------------------------------| | |Split File | | | |------------------------------|-----------------------------------------------------------| | |N of Rows in Working Data File|741 | |----------------------|------------------------------|-----------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-----------------------------------------------------------| | |Cases Used |Statistics are based on all cases with valid data. | |-----------------------------------------------------|-----------------------------------------------------------| |Syntax |frequencies variables=reason. | |----------------------|------------------------------|-----------------------------------------------------------| |Resources |Processor Time |00:00:00.00 | | |------------------------------|-----------------------------------------------------------| | |Elapsed Time |00:00:00.01 | |-----------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Statistics Reason for discontinuation |-|-------|---| |N|Valid |741| | |-------|---| | |Missing|0 | |-------------| Reason for discontinuation |-------------------------------------|---------|-------|-------------|------------------| | |Frequency|Percent|Valid Percent|Cumulative Percent| |-----|-------------------------------|---------|-------|-------------|------------------| |Valid|Method failure |50 |6.7 |6.7 |6.7 | | |-------------------------------|---------|-------|-------------|------------------| | |Desire to become pregnant |203 |27.4 |27.4 |34.1 | | |-------------------------------|---------|-------|-------------|------------------| | |Other fertility related reasons|20 |2.7 |2.7 |36.8 | | |-------------------------------|---------|-------|-------------|------------------| | |Side effects/health concerns |274 |37.0 |37.0 |73.8 | | |-------------------------------|---------|-------|-------------|------------------| | |Wanted more effective method |57 |7.7 |7.7 |81.5 | | |-------------------------------|---------|-------|-------------|------------------| | |Other method related |50 |6.7 |6.7 |88.3 | | |-------------------------------|---------|-------|-------------|------------------| | |Other/DK |87 |11.7 |11.7 |100.0 | | |-------------------------------|---------|-------|-------------|------------------| | |Total |741 |100.0 |100.0 | | |----------------------------------------------------------------------------------------| crosstabs tables=ev903 by reason /count=asis. Crosstabs Notes |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Output Created |15-SEP-2018 16:20:28 | |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Comments | | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Filter |filter$ | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Weight | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Split File | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |N of Rows in Working Data File|741 | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cases Used |Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.| |-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Syntax |crosstabs tables=ev903 by reason /count=asis. | |----------------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------| |Resources |Processor Time |00:00:00.00 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Elapsed Time |00:00:00.01 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Dimensions Requested |2 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------| | |Cells Available |131029 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Case Processing Summary |-------------------------------------------------|-------------------------------------------| | |Cases | | |-------------|---------------|-------------| | |Valid |Missing |Total | | |-----|-------|-------|-------|-----|-------| | |N |Percent|N |Percent|N |Percent| |-------------------------------------------------|-----|-------|-------|-------|-----|-------| |Discontinuation code * Reason for discontinuation|741 |100.0% |0 |0.0% |741 |100.0% | |---------------------------------------------------------------------------------------------| Discontinuation code * Reason for discontinuation Crosstabulation Count |--------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----| | |Reason for discontinuation |Total| | |--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------| | | |Method failure |Desire to become pregnant|Other fertility related reasons|Side effects/health concerns|Wanted more effective method|Other method related|Other/DK| | |--------------------|-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| |Discontinuation code|Became pregnant while using |50 |0 |0 |0 |0 |0 |0 |50 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Wanted to become pregnant |0 |203 |0 |0 |0 |0 |0 |203 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Husband disapproved |0 |0 |0 |0 |0 |0 |35 |35 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Side effects |0 |0 |0 |274 |0 |0 |0 |274 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Access/availability |0 |0 |0 |0 |0 |14 |0 |14 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Wanted more effective method |0 |0 |0 |0 |57 |0 |0 |57 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Inconvenient to use |0 |0 |0 |0 |0 |29 |0 |29 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Infrequent sex/husband away |0 |0 |18 |0 |0 |0 |0 |18 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Cost |0 |0 |0 |0 |0 |7 |0 |7 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Fatalistic |0 |0 |0 |0 |0 |0 |17 |17 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Difficult to get pregnant/menopause|0 |0 |2 |0 |0 |0 |0 |2 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Other |0 |0 |0 |0 |0 |0 |7 |7 | | |-----------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| | |Missing |0 |0 |0 |0 |0 |0 |28 |28 | |--------------------------------------------------------|--------------------------|-------------------------|-------------------------------|----------------------------|----------------------------|--------------------|--------|-----| |Total |50 |203 |20 |274 |57 |50 |87 |741 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| filter off. * switching methods. * switching directly from one method to the next, with no gap. sort cases by caseid ev004 (d). if (caseid = lag(caseid) & ev901+1 = lag(ev900)) switch = 1. * if reason was "wanted more effective method" allow for a 1-month gap. if (ev903 = 7 & ev905 = 0 & caseid = lag(caseid) & ev901+2 >= lag(ev900)) switch = 1. * not a switch if returned back to the same method. * there should be none of these, so there should be no changes from this command. if (caseid = lag(caseid) & ev902 = lag(ev902) & ev901+1 = lag(ev900)) switch = $sysmis. variable labels switch "Switching method". value labels switch 1 "Switched method". formats switch (f1.0). frequencies variables=switch. Frequencies Notes |-----------------------------------------------------|-----------------------------------------------------------| |Output Created |15-SEP-2018 16:20:28 | |-----------------------------------------------------|-----------------------------------------------------------| |Comments | | |----------------------|------------------------------|-----------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav| | |------------------------------|-----------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-----------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-----------------------------------------------------------| | |Filter | | | |------------------------------|-----------------------------------------------------------| | |Weight | | | |------------------------------|-----------------------------------------------------------| | |Split File | | | |------------------------------|-----------------------------------------------------------| | |N of Rows in Working Data File|2356 | |----------------------|------------------------------|-----------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-----------------------------------------------------------| | |Cases Used |Statistics are based on all cases with valid data. | |-----------------------------------------------------|-----------------------------------------------------------| |Syntax |frequencies variables=switch. | |----------------------|------------------------------|-----------------------------------------------------------| |Resources |Processor Time |00:00:00.02 | | |------------------------------|-----------------------------------------------------------| | |Elapsed Time |00:00:00.01 | |-----------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Statistics Switching method |-|-------|----| |N|Valid |121 | | |-------|----| | |Missing|2235| |--------------| Switching method |-----------------------|---------|-------|-------------|------------------| | |Frequency|Percent|Valid Percent|Cumulative Percent| |-------|---------------|---------|-------|-------------|------------------| |Valid |Switched method|121 |5.1 |100.0 |100.0 | |-------|---------------|---------|-------|-------------|------------------| |Missing|System |2235 |94.9 | | | |-----------------------|---------|-------|-------------|------------------| |Total |2356 |100.0 | | | |--------------------------------------------------------------------------| * calculate variable for switching for discontinuations we are using. compute discont_sw=$sysmis. if (switch = 1 & discont = 1) discont_sw = 1. if (sysmis(discont_sw) & ev903 <> 0 & not sysmis(ev903) & discont = 1) discont_sw = 0. variable labels discont_sw "Discontinuation for switching". value labels discont_sw 1 "Switch" 0 "Other reason". formats discont_sw (f1.0). frequencies variables=discont_sw. Frequencies Notes |-----------------------------------------------------|-----------------------------------------------------------| |Output Created |15-SEP-2018 16:20:28 | |-----------------------------------------------------|-----------------------------------------------------------| |Comments | | |----------------------|------------------------------|-----------------------------------------------------------| |Input |Data |C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav| | |------------------------------|-----------------------------------------------------------| | |Active Dataset |eventsfile | | |------------------------------|-----------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-----------------------------------------------------------| | |Filter | | | |------------------------------|-----------------------------------------------------------| | |Weight | | | |------------------------------|-----------------------------------------------------------| | |Split File | | | |------------------------------|-----------------------------------------------------------| | |N of Rows in Working Data File|2356 | |----------------------|------------------------------|-----------------------------------------------------------| |Missing Value Handling|Definition of Missing |User-defined missing values are treated as missing. | | |------------------------------|-----------------------------------------------------------| | |Cases Used |Statistics are based on all cases with valid data. | |-----------------------------------------------------|-----------------------------------------------------------| |Syntax |frequencies variables=discont_sw. | |----------------------|------------------------------|-----------------------------------------------------------| |Resources |Processor Time |00:00:00.00 | | |------------------------------|-----------------------------------------------------------| | |Elapsed Time |00:00:00.01 | |-----------------------------------------------------------------------------------------------------------------| [eventsfile] C:\Users\21180\OneDrive - ICF\Data\DHS_model\eventsfile.sav Statistics Discontinuation for switching |-|-------|----| |N|Valid |741 | | |-------|----| | |Missing|1615| |--------------| Discontinuation for switching |--------------------|---------|-------|-------------|------------------| | |Frequency|Percent|Valid Percent|Cumulative Percent| |-------|------------|---------|-------|-------------|------------------| |Valid |Other reason|620 |26.3 |83.7 |83.7 | | |------------|---------|-------|-------------|------------------| | |Switch |121 |5.1 |16.3 |100.0 | | |------------|---------|-------|-------------|------------------| | |Total |741 |31.5 |100.0 | | |-------|------------|---------|-------|-------------|------------------| |Missing|System |1615 |68.5 | | | |--------------------|---------|-------|-------------|------------------| |Total |2356 |100.0 | | | |-----------------------------------------------------------------------| * Step 3. * Calculate the competing risks cumulative incidence for each method and for total. weight by wt. * Split reason for discontinuation into separate 0/1 variables. recode reason (1 = 1)(else = 0) into reason_1. recode reason (2 = 1)(else = 0) into reason_2. recode reason (3 = 1)(else = 0) into reason_3. recode reason (4 = 1)(else = 0) into reason_4. recode reason (5 = 1)(else = 0) into reason_5. recode reason (6 = 1)(else = 0) into reason_6. recode reason (7 = 1)(else = 0) into reason_7. variable labels reason_1 "Method failure" reason_2 "Desire to become pregnant" reason_3 "Other fertility related reasons" reason_4 "Side effects/health concerns" reason_5 "Wanted more effective method" reason_6 "Other method related" reason_7 "Other/DK". formats reason_1 reason_2 reason_3 reason_4 reason_5 reason_6 reason_7 (f1.0). * Aggregate counts by exposure of totals exposure (N) and discontinuations for each reason. * by method. dataset declare aggr_meth. aggregate /outfile='aggr_meth' /break=method exposure /discont =sum(discont) /reason_1=sum(reason_1) /reason_2=sum(reason_2) /reason_3=sum(reason_3) /reason_4=sum(reason_4) /reason_5=sum(reason_5) /reason_6=sum(reason_6) /reason_7=sum(reason_7) /discont_sw=sum(discont_sw) /expo=N /expo_u=NU. * for All methods. dataset declare aggr_all. aggregate /outfile='aggr_all' /break=exposure /discont =sum(discont) /reason_1=sum(reason_1) /reason_2=sum(reason_2) /reason_3=sum(reason_3) /reason_4=sum(reason_4) /reason_5=sum(reason_5) /reason_6=sum(reason_6) /reason_7=sum(reason_7) /discont_sw=sum(discont_sw) /expo=N /expo_u=NU. * combine file of exposure for all methods and by method into one. dataset activate aggr_meth. add files /file=* /file='aggr_all'. execute. * recode missing to 99 for all methods. recode method (sysmis = 99). * Switch back to the events file for the late entries. dataset activate eventsfile. * Aggregate counts of late entries - to be removed later from cumulative exposure. * by method. dataset declare aggr_late_meth. aggregate /outfile='aggr_late_meth' /break=method entry /lateentry=N /lateentry_u=NU. * for All methods. dataset declare aggr_late_all. aggregate /outfile='aggr_late_all' /break=entry /lateentry=N /lateentry_u=NU. * combine file of late entries for all methods and by method into one. dataset activate aggr_late_meth. add files /file=* /file='aggr_late_all'. execute. * recode missing to 99 for all methods. recode method (sysmis = 99). * drop cases without late entry (entry = 0). select if (entry > 0). * rename late entry variable to exposure. rename variables entry = exposure. * merge the exposure and late entries files into one file by method and exposure. dataset activate aggr_meth. match files /file = * /table = 'aggr_late_meth' /by method exposure. * set any missing late entries and any missing switching to 0. if (sysmis(lateentry)) lateentry = 0. if (sysmis(lateentry_u)) lateentry_u = 0. if (sysmis(discont_sw)) discont_sw = 0. execute. * close separate files that are no longer needed. dataset close aggr_all. dataset close aggr_late_all. dataset close aggr_late_meth. dataset close eventsfile. * Accumulate the exposure and the episodes for the prior months. * reverse the order of the file so longest exposure first to allow for cumulation of the exposures. sort cases method (a) exposure (d). * initialize the cumulative exposure to 0. compute cum_expo = 0. compute episodes = 0. compute cum_expo_u = 0. * if the last month (first entry) for the method, set the cumulative exposure to the monthly exposure minus the late entries. if (missing(lag(method)) or methodlag(method)) cum_expo = expo - lateentry. if (missing(lag(method)) or methodlag(method)) episodes = expo. if (missing(lag(method)) or methodlag(method)) cum_expo_u = expo_u - lateentry_u. * if not the last month (first entry) for the method, * set the cumulative exposure to the previous months cumulative exposure plus the monthly exposure minus the late entries. if (method=lag(method)) cum_expo = lag(cum_expo) + expo - lateentry. if (method=lag(method)) episodes = lag(episodes) + expo. if (method=lag(method)) cum_expo_u = lag(cum_expo_u) + expo_u - lateentry_u. execute. * drop the cases beyond 12 months exposure now as we are only interested in 12 month discontinuation rates. * change to 24 or 36 if two year or three year discontinuation rates are desired. select if (exposure = 12). * resort the data to enable the calculation of the life table. sort cases method (a) exposure (a). * Monthly rates of discontinuation. * Convert counts of discontinuation and switching rates to monthly rates. compute discont = discont/cum_expo. compute discont_sw = discont_sw/cum_expo. compute reason_1 = reason_1/cum_expo. compute reason_2 = reason_2/cum_expo. compute reason_3 = reason_3/cum_expo. compute reason_4 = reason_4/cum_expo. compute reason_5 = reason_5/cum_expo. compute reason_6 = reason_6/cum_expo. compute reason_7 = reason_7/cum_expo. * Construct the life table. do if (exposure = 1). * First month of life table = 1 minus the monthly rate for month 1. + compute lt_reason_1 = 1 - reason_1. + compute lt_reason_2 = 1 - reason_2. + compute lt_reason_3 = 1 - reason_3. + compute lt_reason_4 = 1 - reason_4. + compute lt_reason_5 = 1 - reason_5. + compute lt_reason_6 = 1 - reason_6. + compute lt_reason_7 = 1 - reason_7. + compute lt_discont = 1 - discont. + compute lt_discont_sw = 1 - discont_sw. else. * remaining months. + compute lt_reason_1 = lag(lt_reason_1) - (lag(lt_discont) * reason_1). + compute lt_reason_2 = lag(lt_reason_2) - (lag(lt_discont) * reason_2). + compute lt_reason_3 = lag(lt_reason_3) - (lag(lt_discont) * reason_3). + compute lt_reason_4 = lag(lt_reason_4) - (lag(lt_discont) * reason_4). + compute lt_reason_5 = lag(lt_reason_5) - (lag(lt_discont) * reason_5). + compute lt_reason_6 = lag(lt_reason_6) - (lag(lt_discont) * reason_6). + compute lt_reason_7 = lag(lt_reason_7) - (lag(lt_discont) * reason_7). + compute lt_discont = lag(lt_discont) - (lag(lt_discont) * discont). + compute lt_discont_sw = lag(lt_discont_sw) - (lag(lt_discont) * discont_sw). end if. execute. formats lt_reason_1 lt_reason_2 lt_reason_3 lt_reason_4 lt_reason_5 lt_reason_6 lt_reason_7 lt_discont lt_discont_sw (f8.6). * Step 4. * Total episodes, including late entries can be found in first row of life table use offset of 11 from 12th row to point to first. if (exposure = 12) nepisodes = lag(episodes,11). if (exposure = 12) nexpo_u = lag(cum_expo_u,11). variable labels nepisodes "Number of episodes of use [5]" /nexpo_u "Unweighted exposure in first month". formats nepisodes nexpo_u (f6.0). execute. * Step 5. * Select just the 12 months exposure to report. select if (exposure = 12). * Now extract 12 month discontinuation rates. + compute disc_reason_1 = 100* (1 - lt_reason_1). + compute disc_reason_2 = 100* (1 - lt_reason_2). + compute disc_reason_3 = 100* (1 - lt_reason_3). + compute disc_reason_4 = 100* (1 - lt_reason_4). + compute disc_reason_5 = 100* (1 - lt_reason_5). + compute disc_reason_6 = 100* (1 - lt_reason_6). + compute disc_reason_7 = 100* (1 - lt_reason_7). + compute disc_any = 100* (1 - lt_discont). + compute disc_switch = 100* (1 - lt_discont_sw). formats disc_reason_1 disc_reason_2 disc_reason_3 disc_reason_4 disc_reason_5 disc_reason_6 disc_reason_7 disc_any disc_switch (f5.1). variable labels disc_reason_1 "Method failure" disc_reason_2 "Desire to become pregnant" disc_reason_3 "Other fertility related reasons [1]" disc_reason_4 "Side effects/health reasons" disc_reason_5 "Wanted more effective method" disc_reason_6 "Other method related reasons [2]" disc_reason_7 "Other/DK" disc_any "Any reason [3]" disc_switch "Switched to another method [4]". * Step 6. * Output the table. ctables /vlabels variables=method display=none /vlabels variables=disc_reason_1 disc_reason_2 disc_reason_3 disc_reason_4 disc_reason_5 disc_reason_6 disc_reason_7 disc_any disc_switch nepisodes nexpo_u display=label /format maxcolwidth=55 /table method [c] by (disc_reason_1 + disc_reason_2 + disc_reason_3 + disc_reason_4 + disc_reason_5 + disc_reason_6 + disc_reason_7 + disc_any + disc_switch) [s] [mean,'',f6.1] + (nepisodes + nexpo_u) [s] [mean,'',f8.0] /categories var=all empty=exclude missing=exclude /slabels visible=no /titles title= "Table 7.11 Twelve-month contraceptive discontinuation rates" "Among episodes of contraceptive use experienced within the 5 years preceding the survey, "+ "percentage of episodes discontinued within 12 months, according to reason for "+ "discontinuation and specific method, DHS-6 Model Data" corner="Contraceptive method" caption= "Note: Figures are based on life table calculations using information on episodes of "+ "use that occurred 3-62 months preceding the survey" "[1] Includes infrequent sex/husband away, difficult to get pregnant/menopausal, "+ "and marital dissolution/separation" "[2] Includes lack of access/too far, costs too much, and inconvenient to use" "[3] Reasons for discontinuation are mutually exclusive and add to the total given in "+ "this column" "[4] A woman is considered to have switched to another method if she used a different method "+ "in the month following discontinuation or if she gave 'wanted a more effective method' "+ "as the reason for discontinuation and started another method within two months "+ "of discontinuation." "[5] All episodes of use that occur within the 5 years preceding the survey are included. "+ "Episodes of use include episodes that were discontinued during the period of observation "+ "and episodes of use that were not discontinued during the period of observation." "[6] Includes Female Sterilization, Male sterilization, Other Traditional, Female Condom, "+ "Other Modern, Standard Days Method plus IUD, Periodic Abstinence, and Withdrawal.". Custom Tables Notes |---------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |Output Created |15-SEP-2018 16:20:29 | |---------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |Comments | | |--------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |Input |Active Dataset |aggr_meth | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |File Label |Aggregated File | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |Filter | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |Weight | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |Split File | | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |N of Rows in Working Data File|7 | |---------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |Syntax |ctables /vlabels variables=method display=none /vlabels variables=disc_reason_1 disc_reason_2 disc_reason_3 disc_reason_4 disc_reason_5 disc_reason_6 disc_reason_7 disc_any disc_switch nepisodes nexpo_u display=label /format maxcolwidth=55 /table method [c] by (disc_reason_1 + disc_reason_2 + disc_reason_3 + disc_reason_4 + disc_reason_5 + disc_reason_6 + disc_reason_7 + disc_any + disc_switch) [s] [mean,'',f6.1] + (nepisodes + nexpo_u) [s] [mean,'',f8.0] /categories var=all empty=exclude missing=exclude /slabels visible=no /titles title= "Table 7.11 Twelve-month contraceptive discontinuation rates" "Among episodes of contraceptive use experienced within the 5 years preceding the survey, "+ "percentage of episodes discontinued within 12 months, according to reason for "+ "discontinuation and specific method, DHS-6 Model Data" corner="Contraceptive method" caption= "Note: Figures are based on life table calculations using information on episodes of "+ "use that occurred 3-62 months preceding the survey" "[1] Includes infrequent sex/husband away, difficult to get pregnant/menopausal, "+ "and marital dissolution/separation" "[2] Includes lack of access/too far, costs too much, and inconvenient to use" "[3] Reasons for discontinuation are mutually exclusive and add to the total given in "+ "this column" "[4] A woman is considered to have switched to another method if she used a different method "+ "in the month following discontinuation or if she gave 'wanted a more effective method' "+ "as the reason for discontinuation and started another method within two months "+ "of discontinuation." "[5] All episodes of use that occur within the 5 years preceding the survey are included. "+ "Episodes of use include episodes that were discontinued during the period of observation "+ "and episodes of use that were not discontinued during the period of observation." "[6] Includes Female Sterilization, Male sterilization, Other Traditional, Female Condom, "+ "Other Modern, Standard Days Method plus IUD, Periodic Abstinence, and Withdrawal.".| |--------------|------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |Resources |Processor Time |00:00:00.02 | | |------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | |Elapsed Time |00:00:00.04 | |-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| [aggr_meth] Table 7.11 Twelve-month contraceptive discontinuation rates Among episodes of contraceptive use experienced within the 5 years preceding the survey, percentage of episodes discontinued within 12 months, according to reason for discontinuation and specific method, DHS-6 Model Data |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Contraceptive method|Method failure|Desire to become pregnant|Other fertility related reasons [1]|Side effects/health reasons|Wanted more effective method|Other method related reasons [2]|Other/DK|Any reason [3]|Switched to another method [4]|Number of episodes of use [5]|Unweighted exposure in first month| |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Pill |3.1 |5.6 |.0 |9.4 |3.0 |2.8 |3.0 |26.9 |6.0 |678 |579 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Injectables |1.0 |4.3 |.5 |14.5 |2.3 |.6 |1.8 |24.9 |5.1 |1157 |1007 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Implant |.0 |1.4 |.0 |5.4 |.0 |1.0 |.8 |8.5 |.3 |381 |370 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Male condom |2.0 |15.3 |.9 |3.3 |5.2 |7.5 |8.3 |42.5 |16.3 |137 |80 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |LAM/EC |1.1 |.9 |5.1 |.0 |.0 |.0 |29.1 |36.1 |4.5 |121 |106 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |Other [6] |2.5 |1.7 |.5 |11.9 |2.4 |1.0 |1.5 |21.5 |10.1 |224 |166 | |--------------------|--------------|-------------------------|-----------------------------------|---------------------------|----------------------------|--------------------------------|--------|--------------|------------------------------|-----------------------------|----------------------------------| |All methods |1.6 |4.4 |.5 |10.4 |2.2 |1.6 |3.4 |24.2 |5.6 |2697 |2308 | |-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| Note: Figures are based on life table calculations using information on episodes of use that occurred 3-62 months preceding the survey [1] Includes infrequent sex/husband away, difficult to get pregnant/menopausal, and marital dissolution/separation [2] Includes lack of access/too far, costs too much, and inconvenient to use [3] Reasons for discontinuation are mutually exclusive and add to the total given in this column [4] A woman is considered to have switched to another method if she used a different method in the month following discontinuation or if she gave 'wanted a more effective method' as the reason for discontinuation and started another method within two months of discontinuation. [5] All episodes of use that occur within the 5 years preceding the survey are included. Episodes of use include episodes that were discontinued during the period of observation and episodes of use that were not discontinued during the period of observation. [6] Includes Female Sterilization, Male sterilization, Other Traditional, Female Condom, Other Modern, Standard Days Method plus IUD, Periodic Abstinence, and Withdrawal.